SetConditionalFormatting(CellRange[],Boolean,IConditionalFormattingRule[]) Method

In This Topic

Sets conditional formatting for specified ranges of cells on the sheet based on specified rules.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetConditionalFormatting( _
   ByVal cellRanges() As CellRange, _
   ByVal combinable As Boolean, _
   ByVal ParamArray rules() As IConditionalFormattingRule _
)

'Usage
 
Dim instance As SheetView
Dim cellRanges() As CellRange
Dim combinable As Boolean
Dim rules() As IConditionalFormattingRule
 
instance.SetConditionalFormatting(cellRanges, combinable, rules)

public void SetConditionalFormatting( 
   CellRange[] cellRanges,
   bool combinable,
   params IConditionalFormattingRule[] rules
)

Parameters

cellRanges: The cell ranges
combinable: Rule(s) can be merged into an existing conditional format if they affect the same cell range(s).
rules: The specified rules to apply for a specified range of cells

Example

This example sets the SetConditionalFormatting method.

C#
VB.NET

Reference

SheetView Class
SheetView Members
Overload List